Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 52413 |
| Missing cells | 117953 |
| Missing cells (%) | 14.1% |
| Duplicate rows | 2068 |
| Duplicate rows (%) | 3.9% |
| Total size in memory | 8.8 MiB |
| Average record size in memory | 176.3 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 2 |
14617_FERM0101.DO_2_PV has constant value "0.0" | Constant |
| Dataset has 2068 (3.9%) duplicate rows | Duplicates |
14617_FERM0101.PUMP_1_PV is highly imbalanced (> 99.9%) | Imbalance |
14617_FERM0101.Agitation_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.Air_Sparge_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.Biocontainer_Pressure_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.DO_1_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.DO_2_PV has 51263 (97.8%) missing values | Missing |
14617_FERM0101.Gas_Overlay_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.Load_Cell_Net_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.pH_1_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.pH_2_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.PUMP_1_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.PUMP_1_TOTAL has 4446 (8.5%) missing values | Missing |
14617_FERM0101.PUMP_2_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.PUMP_2_TOTAL has 4446 (8.5%) missing values | Missing |
14617_FERM0101.Single_Use_DO_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.Single_Use_pH_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.Temperatura_PV has 4446 (8.5%) missing values | Missing |
14617_FERM0101.Agitation_PV has 34452 (65.7%) zeros | Zeros |
14617_FERM0101.Air_Sparge_PV has 45976 (87.7%) zeros | Zeros |
14617_FERM0101.DO_1_PV has 32772 (62.5%) zeros | Zeros |
14617_FERM0101.Gas_Overlay_PV has 31673 (60.4%) zeros | Zeros |
14617_FERM0101.Load_Cell_Net_PV has 10498 (20.0%) zeros | Zeros |
14617_FERM0101.PUMP_1_TOTAL has 4773 (9.1%) zeros | Zeros |
14617_FERM0101.PUMP_2_PV has 44757 (85.4%) zeros | Zeros |
14617_FERM0101.PUMP_2_TOTAL has 7917 (15.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-09-29 18:20:20.159473 |
|---|---|
| Analysis finished | 2024-09-29 18:20:37.242020 |
| Duration | 17.08 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
14617_FERM0101.Agitation_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 394 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.849633 |
| Minimum | 0 |
|---|---|
| Maximum | 84 |
| Zeros | 34452 |
| Zeros (%) | 65.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 20 |
| 95-th percentile | 80 |
| Maximum | 84 |
| Range | 84 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 26.725745 |
|---|---|
| Coefficient of variation (CV) | 1.9297078 |
| Kurtosis | 1.7957193 |
| Mean | 13.849633 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8362083 |
| Sum | 664325.34 |
| Variance | 714.26545 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 34452 | |
| 80 | 5817 | 11.1% |
| 20 | 5569 | 10.6% |
| 36 | 1595 | 3.0% |
| 84 | 56 | 0.1% |
| 76.59500122 | 39 | 0.1% |
| 40 | 16 | < 0.1% |
| 44 | 13 | < 0.1% |
| 76.57999878 | 12 | < 0.1% |
| 76.60999756 | 8 | < 0.1% |
| Other values (384) | 390 | 0.7% |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 34452 | |
| 20 | 5569 | 10.6% |
| 20.10310695 | 1 | < 0.1% |
| 20.21899309 | 1 | < 0.1% |
| 20.67293457 | 1 | < 0.1% |
| 20.95280672 | 1 | < 0.1% |
| 20.98088829 | 1 | < 0.1% |
| 20.99491044 | 1 | < 0.1% |
| 21.05531766 | 1 | < 0.1% |
| 21.21556392 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 84 | 56 | 0.1% |
| 80 | 5817 | |
| 79.93813568 | 1 | < 0.1% |
| 79.93371996 | 1 | < 0.1% |
| 79.8770863 | 1 | < 0.1% |
| 79.76942245 | 1 | < 0.1% |
| 79.70800067 | 1 | < 0.1% |
| 79.6834771 | 1 | < 0.1% |
| 79.67000122 | 1 | < 0.1% |
| 79.64278647 | 1 | < 0.1% |
14617_FERM0101.Air_Sparge_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 1992 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6758164 |
| Minimum | 0 |
|---|---|
| Maximum | 160.05262 |
| Zeros | 45976 |
| Zeros (%) | 87.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 160.05262 |
| Range | 160.05262 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 9.4171246 |
|---|---|
| Coefficient of variation (CV) | 5.619425 |
| Kurtosis | 35.829147 |
| Mean | 1.6758164 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.9764025 |
| Sum | 80383.885 |
| Variance | 88.682236 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 45976 | |
| 14.06279144 | 1 | < 0.1% |
| 63.99588593 | 1 | < 0.1% |
| 63.99154193 | 1 | < 0.1% |
| 64.0060196 | 1 | < 0.1% |
| 63.99904114 | 1 | < 0.1% |
| 24.87028503 | 1 | < 0.1% |
| 39.44444275 | 1 | < 0.1% |
| 64.04457215 | 1 | < 0.1% |
| 58.19633405 | 1 | < 0.1% |
| Other values (1982) | 1982 | 3.8% |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 45976 | |
| 0.521129714 | 1 | < 0.1% |
| 0.5400095941 | 1 | < 0.1% |
| 0.5457789322 | 1 | < 0.1% |
| 0.6422712586 | 1 | < 0.1% |
| 0.7333871287 | 1 | < 0.1% |
| 0.7423152386 | 1 | < 0.1% |
| 1.136883879 | 1 | < 0.1% |
| 1.15745287 | 1 | < 0.1% |
| 1.201952457 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 160.0526175 | 1 | |
| 120.9136629 | 1 | |
| 64.54693604 | 1 | |
| 64.52896118 | 1 | |
| 64.4909729 | 1 | |
| 64.44514523 | 1 | |
| 64.428302 | 1 | |
| 64.40546265 | 1 | |
| 64.40250598 | 1 | |
| 64.32200928 | 1 |
14617_FERM0101.Biocontainer_Pressure_PV
Real number (ℝ)
MISSING
| Distinct | 12232 |
|---|---|
| Distinct (%) | 25.5% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 307.40952 |
| Minimum | -13.325246 |
|---|---|
| Maximum | 480 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 13247 |
| Negative (%) | 25.3% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -13.325246 |
|---|---|
| 5-th percentile | -1.9341936 |
| Q1 | -0.14458844 |
| median | 480 |
| Q3 | 480 |
| 95-th percentile | 480 |
| Maximum | 480 |
| Range | 493.32525 |
| Interquartile range (IQR) | 480.14459 |
Descriptive statistics
| Standard deviation | 230.86484 |
|---|---|
| Coefficient of variation (CV) | 0.75100096 |
| Kurtosis | -1.6512982 |
| Mean | 307.40952 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.59024174 |
| Sum | 14745512 |
| Variance | 53298.574 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 480 | 30769 | |
| -0.7841430664 | 177 | 0.3% |
| -0.1157409668 | 145 | 0.3% |
| -0.8044006348 | 143 | 0.3% |
| -0.3385437012 | 132 | 0.3% |
| -0.358795166 | 126 | 0.2% |
| -0.7638916016 | 124 | 0.2% |
| 0.1273132324 | 120 | 0.2% |
| -0.1359924316 | 116 | 0.2% |
| 0.08680419922 | 113 | 0.2% |
| Other values (12222) | 16002 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| -13.32524637 | 1 | |
| -13.28509749 | 1 | |
| -13.27101081 | 1 | |
| -13.26063193 | 1 | |
| -13.26021567 | 1 | |
| -13.25839985 | 1 | |
| -13.25374049 | 1 | |
| -13.25243813 | 1 | |
| -13.24671344 | 1 | |
| -13.24433251 | 1 |
| Value | Count | Frequency (%) |
| 480 | 30769 | |
| 18.87250625 | 1 | < 0.1% |
| 13.41627286 | 1 | < 0.1% |
| 13.08221435 | 1 | < 0.1% |
| 10.25646126 | 1 | < 0.1% |
| 10.24052199 | 1 | < 0.1% |
| 10.20762642 | 1 | < 0.1% |
| 10.10356234 | 1 | < 0.1% |
| 10.08214415 | 1 | < 0.1% |
| 9.777979469 | 1 | < 0.1% |
14617_FERM0101.DO_1_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 3292 |
|---|---|
| Distinct (%) | 6.9% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7917169 |
| Minimum | -0.28136597 |
|---|---|
| Maximum | 99.436316 |
| Zeros | 32772 |
| Zeros (%) | 62.5% |
| Negative | 9263 |
| Negative (%) | 17.7% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -0.28136597 |
|---|---|
| 5-th percentile | -0.28136597 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 22.203763 |
| Maximum | 99.436316 |
| Range | 99.717682 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 9.0688689 |
|---|---|
| Coefficient of variation (CV) | 3.2484916 |
| Kurtosis | 25.001762 |
| Mean | 2.7917169 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.4341461 |
| Sum | 133910.28 |
| Variance | 82.244384 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 32772 | |
| -0.2813659668 | 9254 | 17.7% |
| 24.08387146 | 55 | 0.1% |
| 23.9621933 | 42 | 0.1% |
| 23.7231781 | 41 | 0.1% |
| 23.48416443 | 35 | 0.1% |
| 23.1234726 | 33 | 0.1% |
| 23.60149841 | 27 | 0.1% |
| 23.36248627 | 26 | < 0.1% |
| 24.20555115 | 24 | < 0.1% |
| Other values (3282) | 5658 | 10.8% |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| -0.2813659668 | 9254 | |
| -0.2218725676 | 1 | < 0.1% |
| -0.1898950697 | 1 | < 0.1% |
| -0.1892120976 | 1 | < 0.1% |
| -0.1504498587 | 1 | < 0.1% |
| -0.1471444051 | 1 | < 0.1% |
| -0.1356840012 | 1 | < 0.1% |
| -0.09656236762 | 1 | < 0.1% |
| -0.09238882492 | 1 | < 0.1% |
| -0.0571876545 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99.43631592 | 1 | |
| 88.63425903 | 1 | |
| 84.27712402 | 1 | |
| 84.18154907 | 1 | |
| 81.64790039 | 1 | |
| 81.02649536 | 1 | |
| 80.88638916 | 1 | |
| 80.57045898 | 1 | |
| 80.25758057 | 1 | |
| 80.16330847 | 1 |
14617_FERM0101.DO_2_PV
Categorical
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 51263 |
| Missing (%) | 97.8% |
| Memory size | 2.8 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3450 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 1150 | 2.2% |
| (Missing) | 51263 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 1150 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2300 | |
| . | 1150 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3450 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2300 | |
| . | 1150 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3450 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2300 | |
| . | 1150 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3450 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2300 | |
| . | 1150 |
14617_FERM0101.Gas_Overlay_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 16295 |
|---|---|
| Distinct (%) | 34.0% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4110866 |
| Minimum | 0 |
|---|---|
| Maximum | 20.157114 |
| Zeros | 31673 |
| Zeros (%) | 60.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3.9998521 |
| 95-th percentile | 4.0003124 |
| Maximum | 20.157114 |
| Range | 20.157114 |
| Interquartile range (IQR) | 3.9998521 |
Descriptive statistics
| Standard deviation | 2.1157218 |
|---|---|
| Coefficient of variation (CV) | 1.4993565 |
| Kurtosis | 6.565751 |
| Mean | 1.4110866 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.7455764 |
| Sum | 67685.59 |
| Variance | 4.4762787 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 31673 | |
| 4.000101158 | 1 | < 0.1% |
| 3.998828754 | 1 | < 0.1% |
| 3.999933234 | 1 | < 0.1% |
| 3.997330053 | 1 | < 0.1% |
| 4.000116772 | 1 | < 0.1% |
| 3.999808339 | 1 | < 0.1% |
| 3.999752439 | 1 | < 0.1% |
| 4.000805914 | 1 | < 0.1% |
| 4.000103093 | 1 | < 0.1% |
| Other values (16285) | 16285 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 31673 | |
| 0.3994594589 | 1 | < 0.1% |
| 0.399586808 | 1 | < 0.1% |
| 0.3996747047 | 1 | < 0.1% |
| 0.3997357694 | 1 | < 0.1% |
| 0.3998233359 | 1 | < 0.1% |
| 0.3998823969 | 1 | < 0.1% |
| 0.3998975966 | 1 | < 0.1% |
| 0.3999046079 | 1 | < 0.1% |
| 0.3999054803 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 20.157114 | 1 | |
| 19.77040351 | 1 | |
| 16.63833811 | 1 | |
| 16.02903213 | 1 | |
| 16.00904304 | 1 | |
| 16.00787394 | 1 | |
| 16.00360584 | 1 | |
| 16.00334386 | 1 | |
| 16.00311356 | 1 | |
| 16.00308737 | 1 |
14617_FERM0101.Load_Cell_Net_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 1411 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 440.52991 |
| Minimum | -26.8 |
|---|---|
| Maximum | 1690.8 |
| Zeros | 10498 |
| Zeros (%) | 20.0% |
| Negative | 18103 |
| Negative (%) | 34.5% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -26.8 |
|---|---|
| 5-th percentile | -19.6 |
| Q1 | -1.2 |
| median | 0 |
| Q3 | 1552.4 |
| 95-th percentile | 1660 |
| Maximum | 1690.8 |
| Range | 1717.6 |
| Interquartile range (IQR) | 1553.6 |
Descriptive statistics
| Standard deviation | 714.41842 |
|---|---|
| Coefficient of variation (CV) | 1.6217251 |
| Kurtosis | -0.98159457 |
| Mean | 440.52991 |
| Median Absolute Deviation (MAD) | 4.8 |
| Skewness | 0.99892947 |
| Sum | 21130898 |
| Variance | 510393.67 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 10498 | |
| -1.2 | 7477 | 14.3% |
| 0.4 | 2955 | 5.6% |
| -18 | 1755 | 3.3% |
| -20 | 1607 | 3.1% |
| -19.2 | 1146 | 2.2% |
| -0.4 | 1026 | 2.0% |
| -17.2 | 949 | 1.8% |
| -17.6 | 810 | 1.5% |
| 1.2 | 777 | 1.5% |
| Other values (1401) | 18967 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| -26.8 | 2 | < 0.1% |
| -25.6 | 1 | < 0.1% |
| -24 | 1 | < 0.1% |
| -23.6 | 1 | < 0.1% |
| -22.8 | 2 | < 0.1% |
| -22.4 | 3 | < 0.1% |
| -22 | 6 | < 0.1% |
| -21.6 | 40 | |
| -21.4706807 | 1 | < 0.1% |
| -21.47027313 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1690.8 | 1 | < 0.1% |
| 1686.4 | 1 | < 0.1% |
| 1686.257327 | 1 | < 0.1% |
| 1683.532882 | 1 | < 0.1% |
| 1682.4 | 1 | < 0.1% |
| 1676.4 | 5 | < 0.1% |
| 1676 | 16 | |
| 1675.920587 | 1 | < 0.1% |
| 1675.917904 | 1 | < 0.1% |
| 1675.6 | 16 |
14617_FERM0101.pH_1_PV
Real number (ℝ)
MISSING
| Distinct | 4411 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8089297 |
| Minimum | -0.098877716 |
|---|---|
| Maximum | 7.3847786 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -0.098877716 |
|---|---|
| 5-th percentile | 1.4264652 |
| Q1 | 1.6986334 |
| median | 1.7072765 |
| Q3 | 4.0615554 |
| 95-th percentile | 5.883225 |
| Maximum | 7.3847786 |
| Range | 7.4836563 |
| Interquartile range (IQR) | 2.3629221 |
Descriptive statistics
| Standard deviation | 1.7933123 |
|---|---|
| Coefficient of variation (CV) | 0.63843262 |
| Kurtosis | -0.91855498 |
| Mean | 2.8089297 |
| Median Absolute Deviation (MAD) | 0.12008629 |
| Skewness | 0.87728471 |
| Sum | 134735.93 |
| Variance | 3.2159691 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.707276535 | 13834 | |
| 1.587190247 | 3254 | 6.2% |
| 1.426465225 | 2695 | 5.1% |
| 3.701474762 | 2124 | 4.1% |
| 1.699413681 | 2010 | 3.8% |
| 1.754734039 | 1336 | 2.5% |
| 1.617261124 | 994 | 1.9% |
| 1.761300468 | 796 | 1.5% |
| 1.387585449 | 692 | 1.3% |
| 1.769512177 | 660 | 1.3% |
| Other values (4401) | 19572 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| -0.09887771606 | 2 | < 0.1% |
| 0 | 1 | < 0.1% |
| 0.05516175767 | 1 | < 0.1% |
| 0.09475669861 | 465 | 0.9% |
| 0.1857286453 | 504 | 1.0% |
| 1.234505653 | 3 | < 0.1% |
| 1.358329773 | 576 | 1.1% |
| 1.387585449 | 692 | 1.3% |
| 1.40952301 | 102 | 0.2% |
| 1.426465225 | 2695 |
| Value | Count | Frequency (%) |
| 7.384778595 | 1 | |
| 7.036100349 | 1 | |
| 6.925970143 | 1 | |
| 6.440647437 | 1 | |
| 6.381013253 | 1 | |
| 6.360365931 | 1 | |
| 6.31604864 | 1 | |
| 6.288689423 | 1 | |
| 6.270260368 | 1 | |
| 6.258161131 | 1 |
14617_FERM0101.pH_2_PV
Real number (ℝ)
MISSING
| Distinct | 150 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.1475101 |
| Minimum | -1.9690506 |
|---|---|
| Maximum | 5.8804626 |
| Zeros | 58 |
| Zeros (%) | 0.1% |
| Negative | 20742 |
| Negative (%) | 39.6% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -1.9690506 |
|---|---|
| 5-th percentile | -1.9690506 |
| Q1 | -1.9690506 |
| median | 1.2423117 |
| Q3 | 1.2423117 |
| 95-th percentile | 1.2423117 |
| Maximum | 5.8804626 |
| Range | 7.8495132 |
| Interquartile range (IQR) | 3.2113623 |
Descriptive statistics
| Standard deviation | 1.5771683 |
|---|---|
| Coefficient of variation (CV) | -10.691934 |
| Kurtosis | -1.8806511 |
| Mean | -0.1475101 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.25576757 |
| Sum | -7075.6169 |
| Variance | 2.4874598 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.242311668 | 26562 | |
| -1.969050598 | 19862 | |
| -1.474404144 | 807 | 1.5% |
| 0.1882167816 | 485 | 0.9% |
| 0 | 58 | 0.1% |
| -0.08967628479 | 45 | 0.1% |
| 4.602012253 | 3 | < 0.1% |
| 4.209164047 | 2 | < 0.1% |
| 4.268426895 | 2 | < 0.1% |
| 0.4138712699 | 1 | < 0.1% |
| Other values (140) | 140 | 0.3% |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| -1.969050598 | 19862 | |
| -1.968660417 | 1 | < 0.1% |
| -1.954904932 | 1 | < 0.1% |
| -1.953966074 | 1 | < 0.1% |
| -1.942430316 | 1 | < 0.1% |
| -1.941695419 | 1 | < 0.1% |
| -1.916553858 | 1 | < 0.1% |
| -1.915684722 | 1 | < 0.1% |
| -1.79533771 | 1 | < 0.1% |
| -1.474404144 | 807 | 1.5% |
| Value | Count | Frequency (%) |
| 5.880462646 | 1 | < 0.1% |
| 5.632914734 | 1 | < 0.1% |
| 4.915260569 | 1 | < 0.1% |
| 4.614262791 | 1 | < 0.1% |
| 4.605470657 | 1 | < 0.1% |
| 4.602012253 | 3 | |
| 4.598425674 | 1 | < 0.1% |
| 4.591380692 | 1 | < 0.1% |
| 4.559614182 | 1 | < 0.1% |
| 4.277024841 | 1 | < 0.1% |
14617_FERM0101.PUMP_1_PV
Categorical
IMBALANCE MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Memory size | 2.8 MiB |
| 0.0 | |
|---|---|
| 38.21760524876984 | 1 |
Length
| Max length | 17 |
|---|---|
| Median length | 3 |
| Mean length | 3.0002919 |
| Min length | 3 |
Characters and Unicode
| Total characters | 143915 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 47966 | |
| 38.21760524876984 | 1 | < 0.1% |
| (Missing) | 4446 | 8.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 47966 | |
| 38.21760524876984 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 95933 | |
| . | 47967 | |
| 8 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 143915 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 95933 | |
| . | 47967 | |
| 8 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 143915 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 95933 | |
| . | 47967 | |
| 8 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 143915 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 95933 | |
| . | 47967 | |
| 8 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
14617_FERM0101.PUMP_1_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 137 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.224683 |
| Minimum | 0 |
|---|---|
| Maximum | 287.68032 |
| Zeros | 4773 |
| Zeros (%) | 9.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 24.800002 |
| median | 49.599991 |
| Q3 | 69.439984 |
| 95-th percentile | 287.68032 |
| Maximum | 287.68032 |
| Range | 287.68032 |
| Interquartile range (IQR) | 44.639983 |
Descriptive statistics
| Standard deviation | 66.363623 |
|---|---|
| Coefficient of variation (CV) | 1.033304 |
| Kurtosis | 4.6549292 |
| Mean | 64.224683 |
| Median Absolute Deviation (MAD) | 22.319989 |
| Skewness | 2.1878177 |
| Sum | 3080665.4 |
| Variance | 4404.1304 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 49.59999084 | 14392 | |
| 86.79997559 | 4774 | 9.1% |
| 0 | 4773 | 9.1% |
| 69.43998413 | 4545 | 8.7% |
| 287.6803223 | 2500 | 4.8% |
| 12.4 | 1771 | 3.4% |
| 9.919999695 | 1626 | 3.1% |
| 213.2801758 | 1425 | 2.7% |
| 66.95998535 | 1397 | 2.7% |
| 99.19996948 | 1141 | 2.2% |
| Other values (127) | 9623 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 4773 | |
| 0.07288134248 | 1 | < 0.1% |
| 0.09831839343 | 1 | < 0.1% |
| 0.1558522886 | 1 | < 0.1% |
| 0.3928211376 | 1 | < 0.1% |
| 0.6834257263 | 1 | < 0.1% |
| 0.8258776739 | 1 | < 0.1% |
| 0.8796590074 | 1 | < 0.1% |
| 0.9597338459 | 1 | < 0.1% |
| 1.279374619 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 287.6803223 | 2500 | |
| 229.5887535 | 1 | < 0.1% |
| 225.0604981 | 1 | < 0.1% |
| 224.3762123 | 1 | < 0.1% |
| 213.2801758 | 1425 | |
| 205.8401611 | 2 | < 0.1% |
| 193.4401489 | 6 | < 0.1% |
| 181.0401245 | 4 | < 0.1% |
| 168.6401001 | 50 | 0.1% |
| 161.2000854 | 164 | 0.3% |
14617_FERM0101.PUMP_2_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 2876 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.25268473 |
| Minimum | 0 |
|---|---|
| Maximum | 48 |
| Zeros | 44757 |
| Zeros (%) | 85.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1.1483371 |
| Maximum | 48 |
| Range | 48 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.2018841 |
|---|---|
| Coefficient of variation (CV) | 4.7564573 |
| Kurtosis | 77.349268 |
| Mean | 0.25268473 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.2766134 |
| Sum | 12120.528 |
| Variance | 1.4445254 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 44757 | |
| 8 | 282 | 0.5% |
| 7.610464478 | 21 | < 0.1% |
| 4.800292969 | 4 | < 0.1% |
| 0.1925262451 | 4 | < 0.1% |
| 5.3284052 | 4 | < 0.1% |
| 0.361391449 | 3 | < 0.1% |
| 2.400146484 | 3 | < 0.1% |
| 0.4289131165 | 2 | < 0.1% |
| 1.025171661 | 2 | < 0.1% |
| Other values (2866) | 2885 | 5.5% |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 44757 | |
| 0.0008672121488 | 1 | < 0.1% |
| 0.002711765529 | 1 | < 0.1% |
| 0.003089800865 | 1 | < 0.1% |
| 0.005893559857 | 1 | < 0.1% |
| 0.006319927927 | 1 | < 0.1% |
| 0.006464476075 | 1 | < 0.1% |
| 0.008863561709 | 1 | < 0.1% |
| 0.009584875345 | 1 | < 0.1% |
| 0.009614412571 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 48 | 1 | < 0.1% |
| 8 | 282 | |
| 7.999808115 | 1 | < 0.1% |
| 7.998277201 | 1 | < 0.1% |
| 7.997517177 | 1 | < 0.1% |
| 7.99626271 | 1 | < 0.1% |
| 7.9961447 | 1 | < 0.1% |
| 7.995279122 | 1 | < 0.1% |
| 7.99445011 | 1 | < 0.1% |
| 7.993969818 | 1 | < 0.1% |
14617_FERM0101.PUMP_2_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 4536 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3686.0754 |
| Minimum | 0 |
|---|---|
| Maximum | 9733.4953 |
| Zeros | 7917 |
| Zeros (%) | 15.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1653.925 |
| median | 2014.7377 |
| Q3 | 6974.4906 |
| 95-th percentile | 8224.4727 |
| Maximum | 9733.4953 |
| Range | 9733.4953 |
| Interquartile range (IQR) | 5320.5656 |
Descriptive statistics
| Standard deviation | 3072.6087 |
|---|---|
| Coefficient of variation (CV) | 0.83357186 |
| Kurtosis | -1.4446821 |
| Mean | 3686.0754 |
| Median Absolute Deviation (MAD) | 2014.7377 |
| Skewness | 0.3689617 |
| Sum | 1.7680998 × 108 |
| Variance | 9440924.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2014.737695 | 14386 | |
| 0 | 7917 | |
| 7684.094531 | 4559 | 8.7% |
| 6431.4 | 2980 | 5.7% |
| 7353.300781 | 2498 | 4.8% |
| 8224.472656 | 2215 | 4.2% |
| 6974.490625 | 1421 | 2.7% |
| 6436.503516 | 1420 | 2.7% |
| 2068.205859 | 1281 | 2.4% |
| 9733.495312 | 747 | 1.4% |
| Other values (4526) | 8543 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 7917 | |
| 0.3685405601 | 1 | < 0.1% |
| 0.5414046329 | 1 | < 0.1% |
| 0.712801218 | 77 | 0.1% |
| 1.539999962 | 1 | < 0.1% |
| 1.664988326 | 1 | < 0.1% |
| 3.527600479 | 1 | < 0.1% |
| 3.740000534 | 1 | < 0.1% |
| 5.860414563 | 1 | < 0.1% |
| 7.178785056 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9733.495312 | 747 | |
| 9726.574219 | 1 | < 0.1% |
| 9710.925 | 1 | < 0.1% |
| 9677.501562 | 1 | < 0.1% |
| 9621.399219 | 1 | < 0.1% |
| 9568.690625 | 1 | < 0.1% |
| 9516.520313 | 1 | < 0.1% |
| 9462.626562 | 1 | < 0.1% |
| 9408.087126 | 1 | < 0.1% |
| 9398.410156 | 14 | < 0.1% |
14617_FERM0101.Single_Use_DO_PV
Real number (ℝ)
MISSING
| Distinct | 5912 |
|---|---|
| Distinct (%) | 12.3% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 665.56874 |
| Minimum | 0 |
|---|---|
| Maximum | 799.99199 |
| Zeros | 36 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 18.886434 |
| Q1 | 731.65542 |
| median | 799.99199 |
| Q3 | 799.99199 |
| 95-th percentile | 799.99199 |
| Maximum | 799.99199 |
| Range | 799.99199 |
| Interquartile range (IQR) | 68.336572 |
Descriptive statistics
| Standard deviation | 254.87746 |
|---|---|
| Coefficient of variation (CV) | 0.38294686 |
| Kurtosis | 2.2605398 |
| Mean | 665.56874 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.989021 |
| Sum | 31925336 |
| Variance | 64962.519 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 799.9919922 | 26044 | |
| 734.0049805 | 4572 | 8.7% |
| 741.7635742 | 2869 | 5.5% |
| 562.4240234 | 2723 | 5.2% |
| 731.6554199 | 2314 | 4.4% |
| 661.752002 | 765 | 1.5% |
| 668.7777832 | 686 | 1.3% |
| 738.8861328 | 672 | 1.3% |
| 647.4522461 | 405 | 0.8% |
| 730.252832 | 396 | 0.8% |
| Other values (5902) | 6521 | 12.4% |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 36 | |
| 0.2735763601 | 1 | < 0.1% |
| 0.382732047 | 1 | < 0.1% |
| 1.326502482 | 1 | < 0.1% |
| 1.439416181 | 1 | < 0.1% |
| 1.441547314 | 1 | < 0.1% |
| 1.457331102 | 1 | < 0.1% |
| 1.4895731 | 1 | < 0.1% |
| 1.510649341 | 1 | < 0.1% |
| 1.54550833 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 799.9919922 | 26044 | |
| 793.296952 | 1 | < 0.1% |
| 786.5282593 | 1 | < 0.1% |
| 760.8863618 | 1 | < 0.1% |
| 753.6987261 | 1 | < 0.1% |
| 753.448291 | 8 | < 0.1% |
| 751.4863456 | 1 | < 0.1% |
| 751.0956543 | 183 | 0.3% |
| 747.691063 | 1 | < 0.1% |
| 746.6082783 | 1 | < 0.1% |
14617_FERM0101.Single_Use_pH_PV
Real number (ℝ)
MISSING
| Distinct | 542 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 492.03269 |
| Minimum | -794.36797 |
|---|---|
| Maximum | 800.18398 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1471 |
| Negative (%) | 2.8% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -794.36797 |
|---|---|
| 5-th percentile | 5.6240234 |
| Q1 | 5.8959961 |
| median | 799.87197 |
| Q3 | 800.03999 |
| 95-th percentile | 800.07998 |
| Maximum | 800.18398 |
| Range | 1594.552 |
| Interquartile range (IQR) | 794.14399 |
Descriptive statistics
| Standard deviation | 434.23703 |
|---|---|
| Coefficient of variation (CV) | 0.88253695 |
| Kurtosis | 0.006106933 |
| Mean | 492.03269 |
| Median Absolute Deviation (MAD) | 0.16801758 |
| Skewness | -1.0182299 |
| Sum | 23601332 |
| Variance | 188561.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 800.0399902 | 14960 | |
| 5.895996094 | 4633 | 8.8% |
| 5.624023438 | 3243 | 6.2% |
| 800.0160156 | 2991 | 5.7% |
| 799.8160156 | 2974 | 5.7% |
| 800.0799805 | 2760 | 5.3% |
| 799.8319824 | 1727 | 3.3% |
| 799.9120117 | 1605 | 3.1% |
| 799.8640137 | 1388 | 2.6% |
| 5.727978516 | 1340 | 2.6% |
| Other values (532) | 10346 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| -794.3679688 | 121 | 0.2% |
| -794.1120117 | 274 | 0.5% |
| -794.0959961 | 1 | < 0.1% |
| -788.6240234 | 1 | < 0.1% |
| -788.4799805 | 1 | < 0.1% |
| -788.4560059 | 1 | < 0.1% |
| -788.4399902 | 688 | |
| -788.4080078 | 1 | < 0.1% |
| -788.4 | 12 | < 0.1% |
| -788.3983423 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 800.1839844 | 1128 | 2.2% |
| 800.1199707 | 174 | 0.3% |
| 800.0799805 | 2760 | 5.3% |
| 800.0399902 | 14960 | |
| 800.0160156 | 2991 | 5.7% |
| 799.9120117 | 1605 | 3.1% |
| 799.8719727 | 1135 | 2.2% |
| 799.8640137 | 1388 | 2.6% |
| 799.8319824 | 1727 | 3.3% |
| 799.8160156 | 2974 | 5.7% |
14617_FERM0101.Temperatura_PV
Real number (ℝ)
MISSING
| Distinct | 26641 |
|---|---|
| Distinct (%) | 55.5% |
| Missing | 4446 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.674519 |
| Minimum | 3.0320007 |
|---|---|
| Maximum | 37.616003 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 3.0320007 |
|---|---|
| 5-th percentile | 4.7878371 |
| Q1 | 14.494048 |
| median | 15.939192 |
| Q3 | 17.951895 |
| 95-th percentile | 29.607996 |
| Maximum | 37.616003 |
| Range | 34.584003 |
| Interquartile range (IQR) | 3.4578471 |
Descriptive statistics
| Standard deviation | 6.4424892 |
|---|---|
| Coefficient of variation (CV) | 0.38636733 |
| Kurtosis | 0.25423617 |
| Mean | 16.674519 |
| Median Absolute Deviation (MAD) | 1.8048025 |
| Skewness | 0.39495887 |
| Sum | 799826.63 |
| Variance | 41.505667 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 29.60799561 | 955 | 1.8% |
| 29.59200439 | 837 | 1.6% |
| 29.63199463 | 725 | 1.4% |
| 29.56800537 | 510 | 1.0% |
| 29.64000244 | 260 | 0.5% |
| 23.2 | 228 | 0.4% |
| 29.55999756 | 205 | 0.4% |
| 23.21600342 | 175 | 0.3% |
| 23.19200439 | 142 | 0.3% |
| 3.191998291 | 111 | 0.2% |
| Other values (26631) | 43819 | |
| (Missing) | 4446 | 8.5% |
| Value | Count | Frequency (%) |
| 3.032000732 | 1 | < 0.1% |
| 3.047998047 | 1 | < 0.1% |
| 3.064001465 | 1 | < 0.1% |
| 3.069302299 | 1 | < 0.1% |
| 3.07199707 | 4 | |
| 3.080161001 | 1 | < 0.1% |
| 3.088321318 | 1 | < 0.1% |
| 3.096002197 | 9 | |
| 3.106560762 | 1 | < 0.1% |
| 3.106573962 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 37.61600342 | 1 | < 0.1% |
| 31.6503416 | 1 | < 0.1% |
| 31.50400391 | 1 | < 0.1% |
| 31.39428046 | 1 | < 0.1% |
| 31.31999512 | 1 | < 0.1% |
| 31.25136376 | 1 | < 0.1% |
| 31.24799805 | 5 | < 0.1% |
| 31.24687081 | 1 | < 0.1% |
| 31.24678064 | 1 | < 0.1% |
| 31.24000244 | 24 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| 14617_FERM0101.Agitation_PV | 14617_FERM0101.Air_Sparge_PV | 14617_FERM0101.Biocontainer_Pressure_PV | 14617_FERM0101.DO_1_PV | 14617_FERM0101.DO_2_PV | 14617_FERM0101.Gas_Overlay_PV | 14617_FERM0101.Load_Cell_Net_PV | 14617_FERM0101.pH_1_PV | 14617_FERM0101.pH_2_PV | 14617_FERM0101.PUMP_1_PV | 14617_FERM0101.PUMP_1_TOTAL | 14617_FERM0101.PUMP_2_PV | 14617_FERM0101.PUMP_2_TOTAL | 14617_FERM0101.Single_Use_DO_PV | 14617_FERM0101.Single_Use_pH_PV | 14617_FERM0101.Temperatura_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2023-03-15 00:00:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.319995 |
| 2023-03-15 00:15:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 0.000000 | 800.03999 | 19.240035 |
| 2023-03-15 00:30:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.312000 |
| 2023-03-15 00:45:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.079940 |
| 2023-03-15 01:00:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.192004 |
| 2023-03-15 01:15:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.192997 |
| 2023-03-15 01:30:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.184437 |
| 2023-03-15 01:45:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.247998 |
| 2023-03-15 02:00:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 19.159998 |
| 2023-03-15 02:15:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 18.976328 |
| 14617_FERM0101.Agitation_PV | 14617_FERM0101.Air_Sparge_PV | 14617_FERM0101.Biocontainer_Pressure_PV | 14617_FERM0101.DO_1_PV | 14617_FERM0101.DO_2_PV | 14617_FERM0101.Gas_Overlay_PV | 14617_FERM0101.Load_Cell_Net_PV | 14617_FERM0101.pH_1_PV | 14617_FERM0101.pH_2_PV | 14617_FERM0101.PUMP_1_PV | 14617_FERM0101.PUMP_1_TOTAL | 14617_FERM0101.PUMP_2_PV | 14617_FERM0101.PUMP_2_TOTAL | 14617_FERM0101.Single_Use_DO_PV | 14617_FERM0101.Single_Use_pH_PV | 14617_FERM0101.Temperatura_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2024-09-10 21:45:00.000 | 20.0 | 0.0 | -1.006946 | 0.0 | NaN | 4.000161 | 1567.2 | 5.760351 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 9.128003 |
| 2024-09-10 22:00:00.000 | 20.0 | 0.0 | -1.065306 | 0.0 | NaN | 3.999999 | 1567.2 | 5.768329 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 9.095996 |
| 2024-09-10 22:15:00.000 | 20.0 | 0.0 | -0.931798 | 0.0 | NaN | 4.000085 | 1567.2 | 5.768329 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 9.030962 |
| 2024-09-10 22:30:00.000 | 20.0 | 0.0 | -1.069961 | 0.0 | NaN | 3.999880 | 1567.2 | 5.768329 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 9.005624 |
| 2024-09-10 22:45:00.000 | 20.0 | 0.0 | -1.012910 | 0.0 | NaN | 3.999965 | 1567.2 | 5.776022 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 8.959998 |
| 2024-09-10 23:00:00.000 | 20.0 | 0.0 | -1.006946 | 0.0 | NaN | 4.000245 | 1567.2 | 5.768329 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 8.919995 |
| 2024-09-10 23:15:00.000 | 20.0 | 0.0 | -1.047455 | 0.0 | NaN | 3.999724 | 1567.2 | 5.776022 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 8.880005 |
| 2024-09-10 23:30:00.000 | 20.0 | 0.0 | -1.033430 | 0.0 | NaN | 4.000013 | 1567.2 | 5.776022 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 8.840002 |
| 2024-09-10 23:45:00.000 | 20.0 | 0.0 | -1.087964 | 0.0 | NaN | 4.000077 | 1567.2 | 5.768329 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 8.807996 |
| 2024-09-11 00:00:00.000 | 20.0 | 0.0 | -0.994873 | 0.0 | NaN | 4.000341 | 1567.2 | 5.776022 | -1.474404 | 0.0 | 17.360001 | 0.0 | 0.0 | 799.991992 | 5.895996 | 8.775166 |
Most frequently occurring
| 14617_FERM0101.Agitation_PV | 14617_FERM0101.Air_Sparge_PV | 14617_FERM0101.Biocontainer_Pressure_PV | 14617_FERM0101.DO_1_PV | 14617_FERM0101.DO_2_PV | 14617_FERM0101.Gas_Overlay_PV | 14617_FERM0101.Load_Cell_Net_PV | 14617_FERM0101.pH_1_PV | 14617_FERM0101.pH_2_PV | 14617_FERM0101.PUMP_1_PV | 14617_FERM0101.PUMP_1_TOTAL | 14617_FERM0101.PUMP_2_PV | 14617_FERM0101.PUMP_2_TOTAL | 14617_FERM0101.Single_Use_DO_PV | 14617_FERM0101.Single_Use_pH_PV | 14617_FERM0101.Temperatura_PV | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2067 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4446 |
| 1596 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.552002 | 21 |
| 1585 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.383997 | 20 |
| 1583 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.352002 | 18 |
| 1591 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.471997 | 18 |
| 967 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -1.2 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.064001 | 17 |
| 1009 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -1.2 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.728003 | 17 |
| 1015 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -1.2 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.816003 | 17 |
| 1017 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -1.2 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.856006 | 17 |
| 1573 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | 0.0 | 1.707277 | -1.969051 | 0.0 | 49.599991 | 0.0 | 2014.737695 | 799.991992 | 800.03999 | 16.192004 | 17 |